Performs the calculations inside the parentheses first.
Parentheses are used to control the order of precedence in which the Format Editor calculates a formula. In Basic syntax, they are also used as a string and array subscript.
The following examples are applicable to both Basic and Crystal syntax:
{file.SALES} - {file.COGS} - {file.T&E} * .8
Returns 1000, where SALES=25,000, COGS=12,000, and T&E=15,000.
{file.SALES} - (({file.COGS} - {file.T&E}) * .8)
Returns 27,400, where SALES=25,000, COGS=12,000, and T&E=15,000.
({file.SALES} - {file.COGS} - {file.T&E}) * .8
Returns
Most formula examples use this operator. Select the formula of interest from the Formulas in action index.
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |